A Holistic Approach for Managing Requirements of Data Warehouse Systems
نویسندگان
چکیده
Quantitive evaluations show that many data warehouse projects fail at an alarming rate, wasting all the time, money, and effort spent on them. Cost overruns and schedule delays are attributed in large part, to problems associated with requirements. Therefore, a crucial success factor for the implementation of data warehouse systems is efficient requirements management. In this paper we introduce the easyREMOTE (easy Requirements Modeling Technique for Data WareHouses) requirements management approach, which facilitates an incremental and iterative development of complete, correct, feasible, necessary, prioritized, unambiguous, and verifiable data warehouse requirements. As a foundation we present a requirements specification template with consideration of different stakeholder perspectives and the typical characteristics of data warehouse systems. We discuss traditional requirements management activities (change control, version control, status tracking, requirements tracing) in the context of data warehouse environments and extend these traditional activities to support more efficient requirements documentation and visibility.
منابع مشابه
Controlling the Data Warehouse – a Balanced Scorecard Approach
This paper develops a controlling instrument for data warehouse systems based on the Balanced Scorecard BSC approach. On the basis of the technological aspects of data warehouse systems, the BSC perspectives are developed and populated with relevant objectives and measures for data warehouse success. These perspectives are integrated into a consistent data warehouse scorecard. Finally, this ins...
متن کاملA Holistic Process Performance Analysis through a Performance Data Warehouse
This paper describes how a performance data warehouse can be used to facilitate business process improvement that is based on holistic performance measurement. The feasibility study shows how management and analysis of performance data can be facilitated by a data warehouse approach. It is argued that many of the shortcomings of traditional measurement systems can be overcome with this performa...
متن کاملEliciting Information Requirements for DW Systems
Data Warehouse technology addresses business process analysis. However, it ignores upstream decision-making like formulating policies and policy enforcement rules. We provide a requirements engineering approach for building an integrated data for all types of decisions in an organization. To do this, we develop a two level generic platform with the bottom level having generic models of decision...
متن کاملA Holistic Approach to the Evaluation of Data Warehouse Maintenance Policies
The research community is addressing a number of issues in response to increased reliance of organisations on data warehousing. Most work addresses individual aspects related to incremental view maintenance, propagation algorithms, consistency requirements, performance of OLAP queries etc. There remains a need to consolidate relevant results into a cohesive framework for data warehouse maintena...
متن کاملThe optimal warehouse capacity: A queuing-based fuzzy programming approach
Among the various existing models for the warehousing management, the simultaneous use of private and public warehouses is as the most well-known one. The purpose of this article is to develop a queuing theory-based model for determining the optimal capacity of private warehouse in order to minimize the total corresponding costs. In the proposed model, the available space and budget to create a...
متن کامل